<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Formatting derived elements</title>
<link rel="stylesheet" href="RoboHTML_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='RoboHTML.css'>");}
//-->
</script>
<style type="text/css">
<!--
img_whs1 { border:none; width:23px; height:24px; float:none; border-style:none; }
img_whs2 { border:none; width:185px; height:131px; float:none; border-style:none; }
-->
</style><script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Analyzing report and document results\nGrouping data with new rows, filtering data, and recalculating data: Derived elements\nFormatting derived elements");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Formatting derived elements</h1>
<p>Formatting derived elements lets you highlight important or unique data 
 as well as correctly reflect value and character formats for your derived 
 elements. For example, you may require the values of a derived element 
 to be displayed as a percentage. </p>
<p>Standard formatting of derived elements lets you format all data for 
 an attribute or metric. Formatting a derived metric applies formatting 
 to the metric name and all of its values across all attribute elements.</p>
<p>Formatting the headers of a derived element applies formatting to the 
 derived element name. You can use this to highlight or visually distinguish 
 the various derived elements on the report. </p>
<p>Formatting the values of a derived element applies formatting to all 
 metric values associated with a derived element. You can use this to apply 
 value formats for derived elements that use formulas that return different 
 types of data such as percentages, fractions, or other unique formats.</p>
<p>The procedure below describes how to format derived elements.</p>
<h2>Prerequisites</h2>
<ul><ul>
<li class=p-First-Bullet-Do-Not-Type-Text><p class=First-Bullet-Do-Not-Type-Text>&nbsp;</p></li>
	</ul>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>One of 
 the following must exist: A report connected to an active Intelligent 
 Cube, a Grid/Graph in a Report Services document, or a stand-alone derived 
 element. </p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>Derived 
 elements have been created for the report, Grid/Graph, or stand-alone 
 derived element. </p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>You have 
 the Derived Element Editor open. To open the Derived Elements Editor, 
 see 
<a href="Derived_elements.htm">Working with derived elements</a>.</p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>You have 
 the Define Derived Elements (Desktop) and/or the Web Define Derived Elements 
 (Web) privileges. These privileges are part of the MicroStrategy &nbsp;OLAP 
 Services product.</p></li>
</ul>
<h2>To format derived elements</h2>
<ol>
<li class=p-Steps><p class=Steps>In the Derived Element Editor, select 
 a derived element.</p></li>
	
<li class=p-Steps><p class=Steps>At the top of the Derived Element 
 Editor, click the format icon <img src="images/FormatDerivedElement.gif" x-maintain-ratio="TRUE" width="23px" height="24px" border="0" class="img_whs1">. The Format dialog box opens.</p></li>
	
<li class=p-Steps><p class=Steps>Determine whether to format the attribute 
 elements or the metric values for each attribute element:</p></li>
	<ul>
<li class=p-Steps-Bulleted-1><p class=Steps-Bulleted-1>To format 
 the headers, select <span style="font-weight: bold;"><B>Headers</B></span> from 
 the drop-down menu</p></li>
		
<li class=p-Steps-Bulleted-1><p class=Steps-Bulleted-1>To format 
 the values, select <span style="font-weight: bold;"><B>Values </B></span>from 
 the drop-down menu. &nbsp;</p></li>
	</ul>
	<ul>
<li class=p-Steps-Subtask-Heading><p class=Steps-Subtask-Heading>Format 
 font</p></li>
	</ul>
	
<li class=p-Steps><p class=Steps>On &nbsp;the Font 
 tab, format the font using the following options:</p></li>
	<ul>
<li class=p-Steps-Bulleted-1><p class=Steps-Bulleted-1 style="font-weight: bold;">Font<span 
 style="font-weight: normal;">: Select any font that is installed and available 
 on your machine.</span></p></li>
		
<li class=p-Steps-Bulleted-1><p class=Steps-Bulleted-1 style="font-weight: bold;">Style<span 
 style="font-weight: normal;">: Apply italic and bold effects to the text.</span></p></li>
		
<li class=p-Steps-Bulleted-1><p class=Steps-Bulleted-1 style="font-weight: bold;">Size<span 
 style="font-weight: normal;">: Select any font size that is installed 
 and available on your machine. Choices in this list vary depending on 
 the selected font type.</span></p></li>
		
<li class=p-Steps-Bulleted-1><p class=Steps-Bulleted-1 style="font-weight: bold;">Effects<span 
 style="font-weight: normal;">: Apply an underline or strikeout effects 
 to the control.</span></p></li>
		
<li class=p-Steps-Bulleted-1><p class=Steps-Bulleted-1 style="font-weight: bold;">Color: 
 &nbsp;<span style="font-weight: normal;">Specify a color 
 in which to display the text by clicking the arrow on the color menu and 
 selecting a color.</span></p></li>
		
<li style="list-style: disc;" type=disc class=p><p>Access additional 
 colors by clicking the <span style="font-weight: bold;"><B>More Colors</B></span> 
 button. </p></li>
	</ul>
	<ul>
<li class=p-Steps-No-Number-Indent><p class=Steps-No-Number-Indent>The 
 formatting that you apply is shown in the Sample section of the Font tab.</p></li>
		
<li class=p-Steps-Subtask-Heading><p class=Steps-Subtask-Heading>Format 
 &nbsp;numbers</p></li>
	</ul>
	
<li class=p-Steps><p class=Steps>On the Numbers tab, select one of 
 the following options:</p></li>
	<ul>
<li class=p-Steps-Bulleted-1><p class=Steps-Bulleted-1><span style="font-weight: bold;"><B>Default</B></span>: 
 Numbers are displayed using the default number formatting for the attribute 
 element.</p></li>
		
<li class=p-Steps-Bulleted-1><p class=Steps-Bulleted-1><span style="font-weight: bold;"><B>General</B></span>: 
 Numbers have no specific formatting.</p></li>
		
<li class=p-Steps-Bulleted-1><p class=Steps-Bulleted-1><span style="font-weight: bold;"><B>Fixed</B></span>: 
 Specify the number of decimal places to be displayed as well as how to 
 display negative numbers.</p></li>
		
<li class=p-Steps-Bulleted-1><p class=Steps-Bulleted-1><span style="font-weight: bold;"><B>Currency</B></span>: 
 Specify the number of decimal places to be displayed, the currency symbol 
 to be used, where to display the currency symbol, and how to display negative 
 numbers.</p></li>
		
<li class=p-Steps-Bulleted-1><p class=Steps-Bulleted-1><span style="font-weight: bold;"><B>Date</B></span>: 
 Numbers are displayed as dates. Specify the format to display dates in 
 by selecting one of the examples in the Type field.</p></li>
		
<li class=p-Steps-Bulleted-1><p class=Steps-Bulleted-1><span style="font-weight: bold;"><B>Time</B></span>: 
 Specify the format to display time in by selecting one of the examples 
 in the Type field.</p></li>
		
<li class=p-Steps-Bulleted-1><p class=Steps-Bulleted-1><span style="font-weight: bold;"><B>Percentage</B></span>: 
 Specify the number of decimal places to be displayed and how to display 
 negative numbers.</p></li>
		
<li class=p-Steps-Bulleted-1><p class=Steps-Bulleted-1><span style="font-weight: bold;"><B>Fraction</B></span>: 
 Displays decimals as fractions. Specify the format to display fractions 
 in by selecting one of the examples in the Type field.</p></li>
		
<li class=p-Steps-Bulleted-1><p class=Steps-Bulleted-1><span style="font-weight: bold;"><B>Scientific</B></span>: 
 Displays numbers in scientific notation. Specify the number of decimals 
 to be displayed.</p></li>
		
<li class=p-Steps-Bulleted-1><p class=Steps-Bulleted-1><span style="font-weight: bold;"><B>Custom</B></span>: 
 Specify a custom notation to display numbers in.</p></li>
	</ul>
	<ul>
<li class=p-Steps-Subtask-Heading><p class=Steps-Subtask-Heading>Format 
 alignment</p></li>
	</ul>
	
<li class=p-Steps><p class=Steps>On the alignment tab, format the alignment 
 of the text, text wrapping, text direction, and cell padding using the 
 following options:</p></li>
	<ul>
<li class=p-Steps-Bulleted-1><p class=Steps-Bulleted-1><font style="font-weight: bold;">Text 
 alignment</font>: specifies the horizontal and vertical alignment of text 
 in a cell.</p></li>
		
<li class=p-Steps-Bulleted-2><p class=Steps-Bulleted-2><font style="font-weight: bold;">Horizontal</font>: 
 Specify the horizontal alignment as <span style="font-weight: bold;"><B>General</B></span>, 
 <span style="font-weight: bold;"><B>Left</B></span>, <span style="font-weight: bold;"><B>Center</B></span>, 
 <span style="font-weight: bold;"><B>Right</B></span>, or <span style="font-weight: bold;"><B>Fill</B></span><span>. 
 You can </span>choose to keep the default alignment instead.</p></li>
		<ul>
<li class=p-Steps-No-Number-Indent><p class=Steps-No-Number-Indent><font 
 style="font-weight: bold;">Note</font>: If the width of the cell is longer 
 than the data in it and if you select the <span style="font-weight: bold;"><B>Fill</B></span> 
 option for horizontal alignment, the data is repeated in the cell until 
 the cell is filled. For example, if the data in a cell is $39.00 and you 
 select the Fill option for horizontal alignment, the data in the cell 
 is repeated, displaying as $39.00$39.00$39.00. In MicroStrategy Web, filled 
 cells display as centered in MicroStrategy Web due to the absence of a 
 fill display capability in HTML.</p></li>
		</ul>
		
<li class=p-Steps-Bulleted-2><p class=Steps-Bulleted-2><font style="font-weight: bold;">Vertical</font>: 
 Specify the vertical alignment as <span style="font-weight: bold;"><B>Top</B></span>, 
 <span style="font-weight: bold;"><B>Center</B></span>, or <span style="font-weight: bold;"><B>Bottom</B></span><span>. 
 You can c</span>hoose to keep the default alignment instead.</p></li>
		
<li class=p-Steps-Bulleted-1><p class=Steps-Bulleted-1><font style="font-weight: bold;">Text 
 control</font>: </p></li>
		
<li class=p-Steps-Bulleted-2><p class=Steps-Bulleted-2><font style="font-weight: bold;">Wrap 
 text</font>: Select <span style="font-weight: bold;"><B>Yes</B></span> to display 
 the text on multiple lines within the cell; select <font style="font-weight: bold;">No</font> 
 to display the text on a single line. You can choose to keep the default 
 text wrap instead.</p></li>
		
<li class=p-Steps-Bulleted-2><p class=Steps-Bulleted-2><span style="font-weight: bold;"><B>Text 
 direction</B></span>: Specify whether the text is displayed <span style="font-weight: bold;"><B>Horizontally</B></span> 
 (across the page), <span style="font-weight: bold;"><B>90 degrees</B></span> 
 (vertically from bottom to top ), -<span style="font-weight: bold;"><B>90 
 degrees</B></span> (vertically from top to bottom), as shown below:<br>

		<br>

		<img src="images/textalignment.gif" x-maintain-ratio="TRUE" width="185px" height="131px" border="0" class="img_whs2"><span style="font-weight: bold;"><B><br>

		Note</B></span>: Vertical text is displayed when the report is executed 
 in MicroStrategy Web. Vertical text is not displayed in Desktop or in 
 Design Mode in MicroStrategy Web.</p></li>
		
<li class=p-Steps-Bulleted-1><p class=Steps-Bulleted-1><span style="font-weight: bold;"><B>Padding</B></span>: 
 Adds space between the text and the border of the cell. </p></li>
		
<li class=p-Steps-Bulleted-2><p class=Steps-Bulleted-2><span style="font-weight: bold;"><B>Left</B></span>: 
 Enter the amount of padding between the text and the left border of the 
 cell.</p></li>
	</ul>
	<ul>
<li class=p-Steps-Bulleted-2><p class=Steps-Bulleted-2><span style="font-weight: bold;"><B>Right</B></span>: 
 Enter the amount of padding between the text and the right border of the 
 cell.</p></li>
	</ul>
	<ul>
<li class=p-Steps-Bulleted-2><p class=Steps-Bulleted-2><span style="font-weight: bold;"><B>Top</B></span>: 
 Enter the amount of padding between the text and the top of the cell.</p></li>
	</ul>
	<ul>
<li class=p-Steps-Bulleted-2><p class=Steps-Bulleted-2><span style="font-weight: bold;"><B>Bottom</B></span>: 
 Enter the amount of padding between the text and the bottom of the cell.</p></li>
	</ul>
	<ul>
<li class=p-Steps-Subtask-Heading><p class=Steps-Subtask-Heading>Format 
 color and lines</p></li>
	</ul>
	
<li class=p-Steps><p class=Steps>On &nbsp;the Color 
 and Lines tab, format the color and lines using the following options:</p></li>
	<ul>
<li class=p-Steps-Bulleted-1><p class=Steps-Bulleted-1><span style="font-weight: bold;"><B>Fill</B></span>: 
 Select a color from the drop-down menu to fill the background of the cells.</p></li>
		
<li class=p-Steps-Bulleted-1><p class=Steps-Bulleted-1><span style="font-weight: bold;"><B>Borders</B></span>: 
 Select the style and borders for each cell.</p></li>
		
<li class=p-Steps-Bulleted-2><p class=Steps-Bulleted-2><span style="font-weight: bold;"><B>None</B></span><span>: 
 N</span>o border applied.</p></li>
		
<li class=p-Steps-Bulleted-2><p class=Steps-Bulleted-2><span style="font-weight: bold;"><B>All</B></span><span>: 
 T</span>he same line style and color is applied to the left, right, top 
 and bottom of the cell. Specify the style and color for the borders.</p></li>
		
<li class=p-Steps-Bulleted-2><p class=Steps-Bulleted-2><span style="font-weight: bold;"><B>Custom</B></span>: 
 A different line style and color can be applied to the left, right, top, 
 or bottom of the cell. Specify the line style and color for each line.</p></li>
	</ul>
	<ul>
<li class=p-Steps-Bulleted-1><p class=Steps-Bulleted-1><span style="font-weight: bold;"><B>Flash-only</B></span>: 
 These formatting options are only available for Flash-enabled documents. 
 These options are not available in reports or non-Flash documents:</p></li>
		
<li class=p-Steps-Bulleted-2><p class=Steps-Bulleted-2><span style="font-weight: bold;"><B>Style</B></span><span>: 
 S</span>elect the style for the border from the drop-down menu. </p></li>
		
<li class=p-Steps-Bulleted-2><p class=Steps-Bulleted-2><span style="font-weight: bold;"><B>Color</B></span>: 
 Select the color for the border from the drop-down menu.</p></li>
		
<li class=p-Steps-Bulleted-2><p class=Steps-Bulleted-2><span style="font-weight: bold;"><B>Weight</B></span>: 
 Determines the thickness of the lines that make up the border. Select 
 the weight from the drop-down menu.</p></li>
		
<li class=p-Steps-Subtask-Heading><p class=Steps-Subtask-Heading>Apply 
 the changes</p></li>
	</ul>
	
<li class=p-Steps><p class=Steps>Click <span style="font-weight: bold;"><B>OK</B></span>.<span 
 style="font-weight: bold;"> <B></B></span>The Format dialog box closes.</p></li>
	
<li class=p-Steps><p class=Steps><span>Click </span><span style="font-weight: bold;"><B>OK</B></span><span>. 
 The Derived Element Editor closes.</span></p></li>
</ol>
<p class=Steps>&nbsp; </p>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
